/*
MySQL Backup
Database: ewc
Backup Time: 2021-11-09 13:47:10
*/

SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `ewc`.`ewc_history`;
DROP TABLE IF EXISTS `ewc`.`ewc_services`;
CREATE TABLE `ewc_history` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `occurence_time` datetime DEFAULT NULL,
  `service_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4;
CREATE TABLE `ewc_services` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `service_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;
BEGIN;
LOCK TABLES `ewc`.`ewc_history` WRITE;
DELETE FROM `ewc`.`ewc_history`;
INSERT INTO `ewc`.`ewc_history` (`id`,`occurence_time`,`service_name`) VALUES (4, '2021-11-09 13:39:00', 'serviceA'),(5, '2021-11-09 13:39:20', 'serviceA'),(6, '2021-11-09 13:39:40', 'serviceA'),(7, '2021-11-09 13:40:00', 'serviceA'),(8, '2021-11-09 13:43:40', 'serviceA'),(9, '2021-11-09 13:43:50', 'serviceA'),(10, '2021-11-09 13:44:10', 'serviceC'),(11, '2021-11-09 13:44:20', 'serviceC');
UNLOCK TABLES;
COMMIT;
BEGIN;
LOCK TABLES `ewc`.`ewc_services` WRITE;
DELETE FROM `ewc`.`ewc_services`;
INSERT INTO `ewc`.`ewc_services` (`id`,`service_name`) VALUES (1, 'serviceA'),(2, 'serviceB'),(3, 'serviceC');
UNLOCK TABLES;
COMMIT;
